In Excel, I tried to import (using Data > Import) a CSV file with Chinese characters. The characters are represented as Unicode numeric character references ( ...
When opening the CSV file in an editor (e.g., Excel), explicitly select UTF-8 encoding during the file open process to avoid misinterpretation of characters.
I'm just trying to EDIT a CSV UTF 8 encoded file, using Excel for Office 365, but can't find out how to proceed. it's insane I used to do that a lot in the ...